Returning a REF CURSOR from a procedure (PLSQL)

The OraParameter object representing a cursor variable should be of type ORATYPE_CURSOR, and can only be defined as an output variable. After the PL/SQL block ...

This example demonstrates how to define and open a REF CURSOR variable, and then pass it as a procedure parameter.

2021年7月21日 — I have the following code, which appears to be working fine. As you can in the last piece of SQL the date range is hard coded.

2020年12月2日 — Open the cursor, so that rows can now be fetched from the query. Note: This is a step Oracle Database performs with the SELECT-INTO statement.

2016年11月20日 — Your function is returning a sys_refcursor and in your code you are returning a simple cursor . This makes the code wrong.

2019年4月30日 — I have a function which returns a SYS_REFCURSOR, this function is to be called from different packages and we don't want to have to duplicate ...

2005年5月14日 — Since Oracle 7.3 the REF CURSOR type has been available to allow recordsets to be returned from stored procedures and functions. Oracle 9i ...

2021年9月12日 — Implicit cursors and Explicit cursors · How to use a cursor · Cursor FOR LOOP statement · Cursor with Parameters · Cursor Variables with REF CURSOR ...